Device Event Mapping scripts for Oracle

In the …\OracleDatabaseFiles\DeviceEventMappingScripts\ directory, you will find the device mapping script for OpenWay. Prior to executing the script, check with Itron product management, services, or support to verify that you have the latest version of the script.

  • create_event_mapping_oracle_openway.sql. For Itron OpenWay.

    To enable ItronEE to import events into the system, you must map event codes and labels to IEE internal device event codes. This capability depends on the external system and requires you to use SQL scripts to populate the database table that facilitates the mapping process.

    To execute the script, modify the script to reference the actual external system name to which you are mapping, as it is defined in IEE.

Editing the Device Event Mapping scripts (Oracle)

  1. Find the following line:

    v_externalSystem := 'ReplaceWithExternalSystemName';

  2. Replace the text ‘ReplaceWithExternalSystemName’ with the actual External System Name as defined in IEE.

  3. Run the SQL query.

    You can verify the settings were imported successfully in the IEE client.

Verifying the Device Events imported successfully in the IEE rich client

  1. Go to Device Events > Event CodeMappings.

  2. Use the External System dropdown menu to select the external system ID. If the external system name displays, the settings imported successfully.

Related topics: